Enterprise Database Systems
DA-100: Visualize and Interpret Data in Power BI
DA-100: Creating & Formatting Charts In Power BI
it_dfvpbi_02_enus
DA-100: Leveraging Power BI with Ribbon, Line, Column, & Pie Charts
it_dfvpbi_03_enus
DA-100: Maps, Waterfall Charts, & Scatter Plots in Power BI
it_dfvpbi_04_enus
DA-100: Matrix & Treemap Controls in Power BI
it_dfvpbi_05_enus
DA-100: Understanding Data Visualization
it_dfvpbi_01_enus
DA-100: Using the Power BI Service
it_dfvpbi_06_enus
DA-100: Creating & Formatting Charts In Power BI
Lesson Objectives
DA-100: Creating & Formatting Charts In Power BI
- discover the key concepts covered in this course
- create a column chart in Power BI
- configure a column chart in Power BI
- format a column chart
- toggle and use options for a chart
- color the bars in a bar chart
- create column charts and bar charts
- visualize different types of data in Power BI
- import and transform data in Power Query
- create a line chart
- perform basic and top N filters
- implement advanced filters and create stacked area charts
- summarize the key concepts covered in this course
Overview/Description
Workhorse visualizations, such as line charts, column charts, and bar charts, are beneficial in all visualization use cases. Microsoft Power BI does a great job of making these common charts easy to put together and thoroughly customizable. Take this hands-on course to learn how to create and customize various chart types using Power BI. Learn how to create and customize column charts and bar charts from imported data. Explore how to import time-related data using Power Query and transform it into line charts. Then, experiment with multiple formatting operations on the line chart. Upon course completion, you'll be able to build line, bar, and column charts that are engaging and meaningful and be ready to learn how to create more advanced charts, including ribbon and pie charts. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
Workhorse visualizations, such as line charts, column charts, and bar charts, are beneficial in all visualization use cases. Microsoft Power BI does a great job of making these common charts easy to put together and thoroughly customizable. Take this hands-on course to learn how to create and customize various chart types using Power BI. Learn how to create and customize column charts and bar charts from imported data. Explore how to import time-related data using Power Query and transform it into line charts. Then, experiment with multiple formatting operations on the line chart. Upon course completion, you'll be able to build line, bar, and column charts that are engaging and meaningful and be ready to learn how to create more advanced charts, including ribbon and pie charts. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
Target
Prerequisites: none
DA-100: Leveraging Power BI with Ribbon, Line, Column, & Pie Charts
Lesson Objectives
DA-100: Leveraging Power BI with Ribbon, Line, Column, & Pie Charts
- discover the key concepts covered in this course
- combine line and stacked column charts
- use and configure line and column charts
- create ribbon charts
- explore and navigate the hierarchy of a ribbon chart
- explore the drilldown functionality using a ribbon chart in Power BI
- visualize composition pie charts in Power BI
- create and use donut charts
- link a gauge and table
- create a calculated column in a table and color a gauge
- create funnel charts
- summarize the key concepts covered in this course
Overview/Description
In addition to the ubiquitous line, bar, and column charts, Microsoft Power BI supports other compelling visualizations. These include ribbon charts, a clever way to plot the evolution of both ranks and absolute quantities over time, and funnel charts, useful for representing a linear sequence of events. Advance your Power BI chart-building skills with this hands-on course. Learn how to visualize various kinds of data in the most beneficial way using line and stacked column charts (a combination of line charts and stacked column charts) as well as ribbon, pie, donut, and funnel charts. When you've finished this course, you'll be able to build both standard and specialized charts in Power BI. You'll then be ready to work with maps, waterfall charts, and scatter plots. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
In addition to the ubiquitous line, bar, and column charts, Microsoft Power BI supports other compelling visualizations. These include ribbon charts, a clever way to plot the evolution of both ranks and absolute quantities over time, and funnel charts, useful for representing a linear sequence of events. Advance your Power BI chart-building skills with this hands-on course. Learn how to visualize various kinds of data in the most beneficial way using line and stacked column charts (a combination of line charts and stacked column charts) as well as ribbon, pie, donut, and funnel charts. When you've finished this course, you'll be able to build both standard and specialized charts in Power BI. You'll then be ready to work with maps, waterfall charts, and scatter plots. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
Target
Prerequisites: none
DA-100: Maps, Waterfall Charts, & Scatter Plots in Power BI
Lesson Objectives
DA-100: Maps, Waterfall Charts, & Scatter Plots in Power BI
- discover the key concepts covered in this course
- create a map chart
- visualize geographical data using a map
- visualize sales data using a filled map
- drill through a map
- visualize toy sales for each state in the US with a filled map
- use a waterfall chart
- visualize profits over time with waterfall charts
- visualize data using a scatter plot
- summarize the key concepts covered in this course
Overview/Description
Microsoft Power BI is used in some of the world's largest enterprises. Its powerful map visualizations are great for representing global business data. Its waterfall charts benefit financial planners and analysts, while its scatter plots are ideal for data scientists. Through this practical course, learn how to use Power BI to visualize global business data. Work with Power BI maps, applying various customization techniques. Create waterfall charts for drilling through hierarchical data and representing cumulative processes. Then, create scatter charts to show the relationship between two variables and clusters within data. Lastly, use bubble charts to convey information via the size and color of each point in the chart. When you're done, you'll be able to use multiple advanced charts in Power BI and be ready to work with matrix and treemap controls. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
Microsoft Power BI is used in some of the world's largest enterprises. Its powerful map visualizations are great for representing global business data. Its waterfall charts benefit financial planners and analysts, while its scatter plots are ideal for data scientists. Through this practical course, learn how to use Power BI to visualize global business data. Work with Power BI maps, applying various customization techniques. Create waterfall charts for drilling through hierarchical data and representing cumulative processes. Then, create scatter charts to show the relationship between two variables and clusters within data. Lastly, use bubble charts to convey information via the size and color of each point in the chart. When you're done, you'll be able to use multiple advanced charts in Power BI and be ready to work with matrix and treemap controls. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
Target
Prerequisites: none
DA-100: Matrix & Treemap Controls in Power BI
Lesson Objectives
DA-100: Matrix & Treemap Controls in Power BI
- discover the key concepts covered in this course
- create and group data using matrices
- use hierarchies in matrices
- filter and drill-through matrices
- format Power BI matrices
- apply conditional formatting to a matrix
- use icons as conditional formatting
- visualize the composition of a whole using treemaps
- filter, format, and drill through treemaps
- create hierarchical treemaps
- sync slicers and use them with treemaps
- create and sync slicers across multiple pages
- create slicers for numeric fields and horizontal slicers
- optimize a report for a mobile phone
- summarize the key concepts covered in this course
Overview/Description
As datasets grow larger and more complex, there is an ever-increasing need to organize data into categories and hierarchies. This is what the matrix and treemap controls in Power BI are designed to do. In this course, learn how to utilize matrices and treemaps to their full potential. Create a matrix widget and add aggregations. Create row and column hierarchies from hierarchical fields. Drill through hierarchical treemaps. And format matrices using color scales, data bars, and icons. Additionally, visualize the composition of a whole using treemaps. Learn how to create and filter data through slicers. And sync slicers across different pages and widgets in a report. Upon course completion, you'll have an advanced ability to use Power BI visualizations, ready to move on to using the Power BI service. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
As datasets grow larger and more complex, there is an ever-increasing need to organize data into categories and hierarchies. This is what the matrix and treemap controls in Power BI are designed to do. In this course, learn how to utilize matrices and treemaps to their full potential. Create a matrix widget and add aggregations. Create row and column hierarchies from hierarchical fields. Drill through hierarchical treemaps. And format matrices using color scales, data bars, and icons. Additionally, visualize the composition of a whole using treemaps. Learn how to create and filter data through slicers. And sync slicers across different pages and widgets in a report. Upon course completion, you'll have an advanced ability to use Power BI visualizations, ready to move on to using the Power BI service. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
Target
Prerequisites: none
DA-100: Understanding Data Visualization
Lesson Objectives
DA-100: Understanding Data Visualization
- discover the key concepts covered in this course
- summarize why data visualization is used
- list and describe the purpose of different kinds of visualizations
- outline when to use tables, matrices, and column charts in Power BI
- outline best practices for using line charts, pie charts, bubble charts, and scatter charts
- list and describe the specialized charts in Power BI
- outline the purpose of Power BI reports and how to design them, with reference to features and best practices
- summarize the key concepts covered in this course
Overview/Description
Microsoft Power BI is a powerful and versatile visualization technology widely used in data analytics, especially business data analysis. Business analysts can use this service to build and publish interactive reports for executive audiences as well as collaborators. Get your head around the specifics of data visualization in this introductory course. Explore different types of visualizations and their use-cases, covering standard charts and those for more specific cases. Learn about the structure of Power BI and how it helps with data visualization. Then, examine report creation in Power BI. When you've finished, you'll understand the theory behind data visualization in Power BI and be ready to move on to creating and formatting charts in Power BI. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
Microsoft Power BI is a powerful and versatile visualization technology widely used in data analytics, especially business data analysis. Business analysts can use this service to build and publish interactive reports for executive audiences as well as collaborators. Get your head around the specifics of data visualization in this introductory course. Explore different types of visualizations and their use-cases, covering standard charts and those for more specific cases. Learn about the structure of Power BI and how it helps with data visualization. Then, examine report creation in Power BI. When you've finished, you'll understand the theory behind data visualization in Power BI and be ready to move on to creating and formatting charts in Power BI. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
Target
Prerequisites: none
DA-100: Using the Power BI Service
Lesson Objectives
DA-100: Using the Power BI Service
- discover the key concepts covered in this course
- set up the Power BI service
- pin visuals to a dashboard
- live-pin an entire report to a dashboard
- use the Q&A feature in a Power BI dashboard
- pin a graph from one dashboard to another and change the mobile layout
- summarize the key concepts covered in this course
Overview/Description
Microsoft was a pioneer in desktop applications. But when it adapted to the cloud, it had spectacular success. Similarly, Microsoft's Power BI service has a powerful desktop app in addition to a multifunctional web service. Learn to use the Power BI web service in this hands-on course. Start with publishing reports for other people to view. Then pin visualizations and reports to a dashboard, even live-pinning an entire report to the dashboard. Finally, learn how to use various dashboard features, including the Q&A, which uses natural language processing to answer queries about your data. When you're done, you'll be able to leverage the Power BI Software as a Service and be ready to move on to analyzing and sharing data through Power BI. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
Microsoft was a pioneer in desktop applications. But when it adapted to the cloud, it had spectacular success. Similarly, Microsoft's Power BI service has a powerful desktop app in addition to a multifunctional web service. Learn to use the Power BI web service in this hands-on course. Start with publishing reports for other people to view. Then pin visualizations and reports to a dashboard, even live-pinning an entire report to the dashboard. Finally, learn how to use various dashboard features, including the Q&A, which uses natural language processing to answer queries about your data. When you're done, you'll be able to leverage the Power BI Software as a Service and be ready to move on to analyzing and sharing data through Power BI. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
Target
Prerequisites: none
